OpenCities Map Help

To Use a GUID Field for a New Table

Create a regular feature table, using a varchar2 long enough to store the GUID as the primary key.
CREATE TABLE MY_XFM_GUID
​(ID VARCHAR2(64) PRIMARY KEY,
​Area NUMBER,
​Perimeter NUMBER,
​Building NUMBER,
​Building_ID NUMBER,
​Geometry MDSYS.SDO_GEOMETRY);